Create Visualizations 16 OFFER_RATE and INTERVIEW_RATE OVER YEAR 1) How to create - (1) In Visualizations choose Line Chart - (2) Drag and drop Month ( From Fact_Submission_Interview_Offer ---> SubmissionDate ---> Date Hierachy ---> Month) to Axis - (3) Drag and drop INTERVIEW RATE and OFFER RATE to Values - (4) In Filter Pane ---> Click to SubmissionDate - Month ---> Check Select all and then uncheck Blank 2) Change the visualization - (1) Click to Format -(2) In General change the Width to" 565" and the Height to "250" - (3) Legend ---> Style ---> Choose Line and markers - (4) Turn the Data labels on - (5) Click to Shape ---> turn the Show marker on - (6) Title 6.1 Change the title name to " INTERVIEW RATE AND OFFER RATE OVER MONTH" 6.2 Change the Font color to "White" and Background color to "Blue" 6.3 Choose the Middle Alignment 6.4 Text size 14 - (7) Turn the Border on ---> Change the color to "Blue" OFFER_RATE and INTERVIEW_RATE by JOB _TAG 1) How to create - (1) In Visualizations choose Line and clustered column chart - (2) Drag and drop Jobtag_New column (from Dim_JRP_Tags table) to Shared Axis - (3) Drag and drop OFFER RATE to Column values - (4) Drag and drop INTERVIEW RATE to Line values 2) Change the visualization - (1) Click to Format -(2) In General change the Width to" 565" and the Height to "250" - (3) Legend ---> Style ---> Choose Line and markers - (4) Turn the Data labels on - (5) Click to Shape ---> turn Show marker on - (6) Title 6.1 Change the title name to " INTERVIEW RATE AND OFFER RATE BY JOBTAG" 6.2 Change the Font color to "White" and Background color to "Blue" 6.3 Choose the Middle Alignment 6.4 Text size 14 - (7) Turn the Border on ---> Change the color to "Blue" JOB BY STATE 1) Enable Shape Map - (1) Click to File - (2) Click Options and setting ---> Choose Options - (3) Click Preview features - (4) Check Shape map visual - (5) Click OK -(6) Restart the package 2) Create the Map - (1) In Visualizations choose Shape Map - (2) Drag and drop State column ( Dim_JRP_Clients table ) to Location - (3) Drag and Drop INTERVIEW_RATE to Color saturation 3) Change the visualization - (1) Click to Format - (2) Data colors ---> Choose Light Blue color for minimum and Dark Blue color for Maximum ---> In Minimum box type 0, In Maximum box type 0.15 - (3) Title 3.1 Change the title name to " INTERVIEW RATE BY STATE" 3.2 Change the Font color to "White" and Background color to "Blue" 3.3 Choose the Middle Alignment 3.4 Text size 14 - (4) In General change the Width to" 565" and the Height to "250" - (5) Turn the Border on ---> Change the color to "Blue" Create visual shows the latest time data refresh - Choose table from Visualization - Drag and Drop column Refresh from Fact_JobReferral table to Values - Drag and Drop the table to change the size and move it to the right corner of the Dashboard
OFFER_RATE and INTERVIEW_RATE OVER YEAR
1) How to create
- (1) In Visualizations choose Line Chart
- (2) Drag and drop Month ( From Fact_Submission_Interview_Offer ---> SubmissionDate ---> Date Hierachy --->
Month) to Axis
- (3) Drag and drop INTERVIEW RATE and OFFER RATE to Values
- (4) In Filter Pane ---> Click to SubmissionDate - Month ---> Check Select all and then uncheck Blank
2) Change the visualization
- (1) Click to Format
-(2) In General change the Width to" 565" and the Height to "250"
- (3) Legend ---> Style ---> Choose Line and markers
- (4) Turn the Data labels on
- (5) Click to Shape ---> turn the Show marker on
- (6) Title
6.1 Change the title name to " INTERVIEW RATE AND OFFER RATE OVER MONTH"
6.2 Change the Font color to "White" and Background color to "Blue"
6.3 Choose the Middle Alignment
6.4 Text size 14
- (7) Turn the Border on ---> Change the color to "Blue"
OFFER_RATE and INTERVIEW_RATE by JOB _TAG
- (1) In Visualizations choose Line and clustered column chart
- (2) Drag and drop Jobtag_New column (from Dim_JRP_Tags table) to Shared Axis
- (3) Drag and drop OFFER RATE to Column values
- (4) Drag and drop INTERVIEW RATE to Line values
- (5) Click to Shape ---> turn Show marker on
6.1 Change the title name to " INTERVIEW RATE AND OFFER RATE BY JOBTAG"
JOB BY STATE
1) Enable Shape Map
- (1) Click to File
- (2) Click Options and setting ---> Choose Options
- (3) Click Preview features
- (4) Check Shape map visual
- (5) Click OK
-(6) Restart the package
2) Create the Map
- (1) In Visualizations choose Shape Map
- (2) Drag and drop State column ( Dim_JRP_Clients table ) to Location
- (3) Drag and Drop INTERVIEW_RATE to Color saturation
3) Change the visualization
- (2) Data colors ---> Choose Light Blue color for minimum and Dark Blue color for Maximum ---> In Minimum
box type 0, In Maximum box type 0.15
- (3) Title
3.1 Change the title name to " INTERVIEW RATE BY STATE"
3.2 Change the Font color to "White" and Background color to "Blue"
3.3 Choose the Middle Alignment
3.4 Text size 14
- (4) In General change the Width to" 565" and the Height to "250"
- (5) Turn the Border on ---> Change the color to "Blue"
Create visual shows the latest time data refresh
- Choose table from Visualization
- Drag and Drop column Refresh from Fact_JobReferral table to Values
- Drag and Drop the table to change the size and move it to the right corner of the Dashboard
visualization option in power bi clicks below to know more.
https://www.tutorialspoint.com/power_bi/power_bi_visualization_options.htm